use Inventory_Management;
go
insert into Administrator values('Nguyen Quang Khanh','khanhnguyen','123456');
select *from Administrator;

insert into Supplier values('trung anh','hoang mai','091658954');
insert into Supplier values('thanh tung','hai ba trung','098658954');
select *from Supplier;

insert into Product_Category values('dien tu','tivi, tu lanh, may giat dieu hoa');
insert into Product_Category values('may','xe may, o to, xe dap');
select* from Product_Category;

insert into Product values('ti vi','dv1',3000000,5,null,2012/1/1,1,1,1);
insert into Product values('xe may','dv2',15000000,20,null,2010/6/1,1,2,2);
select *from Product;

insert into Customer values('nguyen van A','nam',20,01699993658,'hang mai','a@gmail.com');
select *from Customer;

insert into Staff values('nguyen tuan anh','tuannv','123456','nam',20,'0166365895','Ha Nam','tuan@gmail.com','ban hang');
insert into Staff values('Dao Ngoc Ha','hanv','123456','nam',20,'0165765895','Hai Duong','ha@gmail.com','giao hang');
select *from Staff;

insert into Bill values(1,'Tien mat',6000000,2013/12/17,1);
select *from Bill;

insert into Bill_Detail values(1,2,2,3000000);
select *from Bill_Detail;
